============================================================================== Simba Salesforce JDBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Salesforce JDBC Connector 2.1.26, as well as the version history. 2.1.26 ======================================================================= Released 2024-12-20 Enhancements & New Features * [SFJDBC-979] Support for Salesforce API version The connector now uses Salesforce API version 62. Previously, the connector used version 54. For more information, see the Installation and Configuration Guide. * [SFJDBC-980] Updated third-party library The connector has been upgraded with the following third-party libraries: - commons-codec 1.17.0 (previously 1.13) - commons-logging 1.2 (previously 1.3.2) - jackson-annotations 2.17.3 (previously 2.15.2) - jackson-core 2.17.3 (previously 2.15.2) - jackson-databind 2.17.3 (previously 2.15.2) - moshi 1.12.0 (previously 1.15.1) - okio-jvm 3.9.0 (previously 2.10.0) - kotlin-stdlib 1.9.24 (previously 1.15.21) Resolved Issues The following issue has been resolved in Simba Salesforce JDBC Connector 2.1.26. * [SFJDBC-969] When writing the date and time values, the adapter returns an error. Workflow Changes ============================================================= The following changes may disrupt established workflows for the connector. 2.1.22 ----------------------------------------------------------------------- * [SFJDBC-733] Remove Jackson Mapper ASL Beginning with this release, Jackson Mapper ASL 1.9.13 has been removed from the third-party dependencies. Version History ============================================================== 2.1.24 ----------------------------------------------------------------------- Released 2023-06-14 Enhancements & New Features * [SFJDBC-770] Support for Salesforce API version 54 The connector now uses Salesforce API version 54. Previously, the connector used version 52. Resolved Issues The following issues have been resolved in Simba Salesforce JDBC Connector 2.1.24. * [SFJDBC-624] In some cases, when the metadata resilience option is disabled, the bulk requests fail. * [SFJDBC-772] When the Client Secret parameter is not configured in the OAuth application, the OAuth connection fails to retrieve the report list. * [SFJDBC-780] The connector does not convert date to datetime in the newly created reports. * [SFJDBC-804] When queries go through the Bulk API fallback mechanism, the query fails. * [SFJDBC-822] The connector handles Base64 data type decryption incorrectly. * [SFJDBC-824] In some cases, when inserting jobs using the Bulk API, the connector fails. 2.1.23.1026 ------------------------------------------------------------------ Released 2022-06-30 Resolved Issues The following issue has been resolved in Simba Salesforce JDBC Connector 2.1.23.1026. * [SFJDBC-773] Requests to the Reports API generate an incorrect resource URL, and fail with the error message "Unknown Salesforce Reporting API error from Describe call". 2.1.23 ----------------------------------------------------------------------- Released 2022-04-22 Enhancements & New Features * [SFJDBC-763] Upgraded Jackson library The connector now uses version 2.13.2 of the Jackson library. Previously, it used version 2.11.3. 2.1.22 ----------------------------------------------------------------------- Released 2022-02-08 Enhancements & New Features * [SFJDBC-728] Updated OAuth connection property For OAuth connections, you can now authenticate with Client Secret. To do this, type your Consumer Secret property in the OAuth Client Secret field. For more information, see the Installation and Configuration Guide. * [SFJDBC-734] Upgraded third-party library The connector now uses Apache HttpComponents HttpClient 4.5.13. Previously, the connector used 4.5.10. * [SFJDBC-741] Updated REST API configuration When a bulk query fails, the connector can now disable fallback to the REST API. To do this, set the Disable REST Fallback option to yes. For more information, see the Installation and Configuration Guide. Resolved Issues The following issues have been resolved in Simba Salesforce JDBC Connector 2.1.22. * [SFJDBC-735] When querying object metadata and CDC is enabled, the ResultSet object prematurely closes. * [SFJDBC-745] When connecting using the OAuth refresh token, the connector returns a NullPointerException error. 2.1.21 ----------------------------------------------------------------------- Released 2021-09-24 Enhancements & New Features * [SFJDBC-637] Support for Java 11 The connector now supports Java 11. * [SFJDBC-691] Upgraded third-party library The connector now uses Moshi 1.12.0 for parsing JSON. Previously, the connector used Google GSON 2.8.5. * [SFJDBC-691] Updated SOQL support The connector now supports the SOQL FIELDS function. * [SFJDBC-711] Support for Salesforce API version 52 The connector now uses Salesforce API version 52. Previously, the connector used version 48. Resolved Issues The following issues have been resolved in Simba Salesforce JDBC Connector 2.1.21. * [SFJDBC-664] The connector incorrectly converts bit values of 1 to false. * [SFJDBC-681] In some cases, when retrieving metadata for objects whose SOAP type is datetime, the connector returns an error. * [SFJDBC-693] The connector does not retrieve report lists from Salesforce instances hosted on a domain whose suffix is not salesforce.com. * [SFJDBC-696] When calling DatabaseMetaData.allTablesAreSelectable() and there are standard objects that cannot be queried, the connector incorrectly returns true. * [SFJDBC-700] When retrieving large volumes of data with the Bulk API, the connector returns a partial amount of the data. * [SFJDBC-701] When a REST query fails with an OPERATION_TOO_LARGE error, the connector does not execute queries using the Bulk API. 2.1.20 ----------------------------------------------------------------------- Released 2021-06-18 Enhancements & New Features * [SFJDBC-685] Trace logging You can now configure the connector to generate trace-level connection logs from the Salesforce web server connector, in addition to the standard connector logs. To do this, set the EnableWSCTraceLogging property to 1. For more information, see the Installation and Configuration Guide. Warning: Enabling this property captures the authentication credentials in plain text. Use this feature at your own risk. * [SFJDBC-678] Support for Salesforce Shield and Real-Time Event Monitoring The connector now supports standard objects that are part of the Salesforce Shield or Real-Time Event Monitoring add-on subscriptions. * [SFJDBC-685] Downgraded GSON library The connector now uses version 2.8.5 of the GSON library. Previously the connector used version 2.8.6. * [SFJDBC-645] Upgraded Jackson library The connector now uses version 2.11.3 of the Jackson library. Resolved Issues The following issues have been resolved in Simba Salesforce JDBC Connector 2.1.20. * [SFJDBC-672] If an initial REST query fails with a QUERY_TIMEOUT response, the query terminates even when Bulk API querying is enabled. This issue has been resolved. The connector now attempts to execute the query through the Bulk API. * [SFJDBC-673] If a query contains a '+' sign, for example, "SELECT Name FROM Account WHERE CreatedDate > 2005-10-08T01:02:03+05:30 ORDER BY Name", the query is not properly URL-encoded and fails. 2.1.19 ----------------------------------------------------------------------- Released 2021-01-15 Enhancements & New Features * [SFJDBC-644] Support for Salesforce API version 48 The driver now uses Salesforce API version 48. Previously, the driver used version 46. * [SFJDBC-652] UPDATE and UPSERT support On Salesforce objects containing the master-detail relationship field, the driver now supports UPDATE and UPSERT operations without requiring the Reparentable Master Detail option to be selected. However, if the query being executed modifies the value of the master-detail relationship field, the driver requires the Reparentable Master Detail option to be selected. 2.1.18 ----------------------------------------------------------------------- Released 2019-09-27 Enhancements & New Features * [SFJDBC-565] Support for JDBC 4.1 and 4.2 The driver is now available as JDBC 4.1 and 4.2 installation packages. For more information, see the Installation and Configuration Guide. * [SFJDBC-589] Support for Lightning Experience The driver now support retrieving reports from accounts with Lightning Experience. * [SFJDBC-616] Support for Salesforce API version 46 The driver now uses Salesforce API version 46. Salesforce API version 44 was used previously. Resolved Issues The following issues have been resolved in Simba Salesforce JDBC Driver 2.1.18. * [SFJDBC-599] The driver fails to authenticate connections to proxy servers that require authentication. This issue has been resolved. A new third-party jar, commons-codec-1.12.jar has been added to support proxy authentication. * [SFJDBC-607] UPDATE queries do not update blank strings. 2.1.15 ----------------------------------------------------------------------- Released 2019-04-09 Resolved Issues The following issue has been resolved in Simba Salesforce JDBC Driver 2.1.15. * [SFJDBC-579] In some cases, the driver returns dataType mapping error. 2.1.14 ----------------------------------------------------------------------- Released 2018-11-16 Enhancements & New Features * Support for Salesforce API version 44 The driver now uses Salesforce API version 44. Salesforce API version 41 was used previously. 2.1.13 ----------------------------------------------------------------------- Released 2018-03-29 Enhancements & New Features * Bulk Query support for SOQL queries The driver now uses bulk API for fetching large data sets in SOQL mode. The driver also uses the bulk API for relationship queries, improving performance. * QueryAll support for bulk queries The driver now uses bulk API for queries even when the queryAll is set to true. ==============================================================================